1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
import type { APIRoute } from 'astro';
export const prerender = false;
export const PUT: APIRoute = async ({ params, request, locals }) => {
try {
const db = locals.runtime.env.DB;
const id = params.id;
const body = await request.json();
const { title, description, completed } = body;
const { results } = await db.prepare(
'UPDATE tasks SET title = ?, description = ?, completed = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ? RETURNING *'
).bind(title, description || '', completed || false, id).all();
if (results.length === 0) {
return new Response(JSON.stringify({ error: 'Task not found' }), {
status: 404,
headers: { 'Content-Type': 'application/json' }
});
}
return new Response(JSON.stringify(results[0]), {
status: 200,
headers: { 'Content-Type': 'application/json' }
});
} catch (error) {
return new Response(JSON.stringify({ error: 'Failed to update task' }), {
status: 500,
headers: { 'Content-Type': 'application/json' }
});
}
};
export const DELETE: APIRoute = async ({ params, locals }) => {
try {
const db = locals.runtime.env.DB;
const id = params.id;
const { success } = await db.prepare('DELETE FROM tasks WHERE id = ?').bind(id).run();
if (!success) {
return new Response(JSON.stringify({ error: 'Task not found' }), {
status: 404,
headers: { 'Content-Type': 'application/json' }
});
}
return new Response(JSON.stringify({ message: 'Task deleted successfully' }), {
status: 200,
headers: { 'Content-Type': 'application/json' }
});
} catch (error) {
return new Response(JSON.stringify({ error: 'Failed to delete task' }), {
status: 500,
headers: { 'Content-Type': 'application/json' }
});
}
};
|
